namespace KDS.Mes.Migrations
{
    using System;
    using System.Collections.Generic;
    using System.Data.Entity.Infrastructure.Annotations;
    using System.Data.Entity.Migrations;
    
    public partial class AddBasicBomPlan : DbMigration
    {
        public override void Up()
        {
            //CreateTable(
            //    "dbo.T_BomAlcCode",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            StyleId = c.Int(nullable: false),
            //            ALCCode = c.String(nullable: false, maxLength: 20),
            //            CarStyle = c.String(nullable: false, maxLength: 50),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_AlcCode_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_BomStyle", t => t.StyleId, cascadeDelete: true)
            //    .Index(t => t.StyleId);
            
            //CreateTable(
            //    "dbo.T_BomStyle",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            CartypeId = c.Int(nullable: false),
            //            StyleName = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Style_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_BomCartype", t => t.CartypeId, cascadeDelete: true)
            //    .Index(t => t.CartypeId);
            
            //CreateTable(
            //    "dbo.T_BomCartype",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            CartypeName = c.String(nullable: false, maxLength: 20),
            //            CartypeCode = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Cartype_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id);
            
            //CreateTable(
            //    "dbo.T_BomALC",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            CartypeId = c.Int(nullable: false),
            //            Code = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Alc_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_BomCartype", t => t.CartypeId, cascadeDelete: true)
            //    .Index(t => t.CartypeId);
            
            //CreateTable(
            //    "dbo.T_BomColor",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            ColorName = c.String(nullable: false, maxLength: 20),
            //            ColorCode = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Color_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id);
            
            //CreateTable(
            //    "dbo.T_BasicFactory",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            FactoryName = c.String(nullable: false, maxLength: 20),
            //            FactoryCode = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Factory_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id);
            
            //CreateTable(
            //    "dbo.T_BomLineAlcCode",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            LineId = c.Int(nullable: false),
            //            AlcCodeId = c.Int(nullable: false),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_LineAlcCode_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_BomAlcCode", t => t.AlcCodeId, cascadeDelete: true)
            //    .ForeignKey("dbo.T_BasicLine", t => t.LineId, cascadeDelete: true)
            //    .Index(t => t.LineId)
            //    .Index(t => t.AlcCodeId);
            
            //CreateTable(
            //    "dbo.T_BasicLine",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            WorkshopId = c.Int(nullable: false),
            //            ProductModeId = c.Int(nullable: false),
            //            LineName = c.String(nullable: false, maxLength: 20),
            //            LineCode = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Line_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_ProductMode", t => t.ProductModeId, cascadeDelete: true)
            //    .ForeignKey("dbo.T_BasicWorkshop", t => t.WorkshopId, cascadeDelete: true)
            //    .Index(t => t.WorkshopId)
            //    .Index(t => t.ProductModeId);
            
            //CreateTable(
            //    "dbo.T_ProductMode",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            ProductModeName = c.String(nullable: false, maxLength: 20),
            //            ProductModeCode = c.String(nullable: false, maxLength: 20),
            //            IsDefault = c.Boolean(nullable: false),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_ProductMode_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id);
            
            //CreateTable(
            //    "dbo.T_BasicWorkshop",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            FactoryId = c.Int(nullable: false),
            //            WorkshopName = c.String(nullable: false, maxLength: 20),
            //            WorkshopCode = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Workshop_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_BasicFactory", t => t.FactoryId, cascadeDelete: true)
            //    .Index(t => t.FactoryId);
            
            //CreateTable(
            //    "dbo.T_BomMaterial",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            MaterialName = c.String(nullable: false, maxLength: 20),
            //            MaterialCode = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Material_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id);
            
            //CreateTable(
            //    "dbo.T_BomPart",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            AlcCodeId = c.Int(nullable: false),
            //            SeatPositionId = c.Int(nullable: false),
            //            SeatNo = c.String(maxLength: 20),
            //            BackrestAssemblyNo = c.String(maxLength: 20),
            //            CushionAssemblyNo = c.String(maxLength: 20),
            //            SlideNo = c.String(maxLength: 20),
            //            BackrestCoverNo = c.String(maxLength: 20),
            //            CushionCoverNo = c.String(maxLength: 20),
            //            BackrestFoamNo = c.String(maxLength: 20),
            //            CushionFoamNo = c.String(maxLength: 20),
            //            BackFrameNo = c.String(maxLength: 20),
            //            SABNo = c.String(maxLength: 20),
            //            HeadrestNo = c.String(maxLength: 20),
            //            CenterHeadrestNo = c.String(maxLength: 20),
            //            ArmRestNo = c.String(maxLength: 20),
            //            BuckleNo = c.String(maxLength: 20),
            //            BackplaneNo = c.String(maxLength: 20),
            //            AdjusterNo = c.String(maxLength: 20),
            //            AdjusterPlateNo = c.String(maxLength: 20),
            //            CushioSsupportNo = c.String(maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Part_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_BomAlcCode", t => t.AlcCodeId, cascadeDelete: true)
            //    .ForeignKey("dbo.T_BomSeatPosition", t => t.SeatPositionId, cascadeDelete: true)
            //    .Index(t => t.AlcCodeId)
            //    .Index(t => t.SeatPositionId);
            
            //CreateTable(
            //    "dbo.T_BomSeatPosition",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            SeatPositionName = c.String(nullable: false, maxLength: 20),
            //            SeatPositionCode = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_SeatPosition_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id);

            //CreateTable(
            //    "dbo.T_PlanDetail",
            //    c => new
            //    {
            //        Id = c.Int(nullable: false, identity: true),
            //        PlanId = c.Int(nullable: false),
            //        SeatPositionId = c.Int(nullable: false),
            //        SeatID = c.String(nullable: false, maxLength: 50),
            //        SeatSeq = c.Int(nullable: false),
            //            IsOnline01 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline02 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline03 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline04 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline05 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline06 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline07 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline08 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline09 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline10 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline11 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline12 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline13 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline14 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline15 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline16 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline17 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline18 = c.Int(nullable: false,defaultValue:0),
            //            IsOnline19 = c.Int(nullable: false,defaultValue:0),
            //        IsOnline20 = c.Int(nullable: false, defaultValue: 0),
            //        })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_Plan", t => t.PlanId, cascadeDelete: true)
            //    .ForeignKey("dbo.T_BomSeatPosition", t => t.SeatPositionId, cascadeDelete: true)
            //    .Index(t => t.PlanId)
            //    .Index(t => t.SeatPositionId);
            
            //CreateTable(
            //    "dbo.T_Plan",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            LineId = c.Int(nullable: false),
            //            AlcCodeId = c.Int(nullable: false),
            //            PlanModeId = c.Int(nullable: false),
            //            Priority = c.Int(nullable: false),
            //            PlanQty = c.Int(nullable: false),
            //            PlanDate = c.DateTime(nullable: false),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Plan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_BomAlcCode", t => t.AlcCodeId, cascadeDelete: true)
            //    .ForeignKey("dbo.T_BasicLine", t => t.LineId, cascadeDelete: true)
            //    .ForeignKey("dbo.T_PlanMode", t => t.PlanModeId, cascadeDelete: true)
            //    .Index(t => t.LineId)
            //    .Index(t => t.AlcCodeId)
            //    .Index(t => t.PlanModeId);
            
            //CreateTable(
            //    "dbo.T_PlanMode",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            PlanModeName = c.String(nullable: false, maxLength: 20),
            //            PlanModeCode = c.String(nullable: false, maxLength: 20),
            //            IsDefault = c.Boolean(nullable: false),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_PlanMode_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id);
            
            //CreateTable(
            //    "dbo.T_BomProcessType",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            ProcessName = c.String(nullable: false, maxLength: 20),
            //            ProcessCode = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_ProcessType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id);
            
            //CreateTable(
            //    "dbo.T_BomSeatInfo",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            AlcCodeId = c.Int(nullable: false),
            //            SeatPositionId = c.Int(nullable: false),
            //            ColorId = c.Int(nullable: false),
            //            MaterialId = c.Int(nullable: false),
            //            Slide = c.Byte(nullable: false),
            //            HGIT = c.Byte(nullable: false),
            //            LumbarSupport = c.Byte(nullable: false),
            //            Warmer = c.Byte(nullable: false),
            //            Ventlation = c.Byte(nullable: false),
            //            SAB = c.Byte(nullable: false),
            //            BackPocket = c.Byte(nullable: false),
            //            SBR = c.Byte(nullable: false),
            //            IMS = c.Byte(nullable: false),
            //            OneTouch = c.Byte(nullable: false),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_SeatInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_BomAlcCode", t => t.AlcCodeId, cascadeDelete: true)
            //    .ForeignKey("dbo.T_BomColor", t => t.ColorId, cascadeDelete: true)
            //    .ForeignKey("dbo.T_BomMaterial", t => t.MaterialId, cascadeDelete: true)
            //    .ForeignKey("dbo.T_BomSeatPosition", t => t.SeatPositionId, cascadeDelete: true)
            //    .Index(t => t.AlcCodeId)
            //    .Index(t => t.SeatPositionId)
            //    .Index(t => t.ColorId)
            //    .Index(t => t.MaterialId);
            
            //CreateTable(
            //    "dbo.T_BasicStation",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            LineId = c.Int(nullable: false),
            //            StationName = c.String(nullable: false, maxLength: 20),
            //            StationCode = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Station_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.T_BasicLine", t => t.LineId, cascadeDelete: true)
            //    .Index(t => t.LineId);
            
            //CreateTable(
            //    "dbo.T_BasicStorage",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            StorageName = c.String(nullable: false, maxLength: 20),
            //            StorageCode = c.String(nullable: false, maxLength: 20),
            //            IsDeleted = c.Boolean(nullable: false),
            //            DeleterUserId = c.Long(),
            //            DeletionTime = c.DateTime(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        },
            //    annotations: new Dictionary<string, object>
            //    {
            //        { "DynamicFilter_Storage_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //    })
            //    .PrimaryKey(t => t.Id);
            
        }
        
        public override void Down()
        {
            //    DropForeignKey("dbo.T_BasicStation", "LineId", "dbo.T_BasicLine");
            //    DropForeignKey("dbo.T_BomSeatInfo", "SeatPositionId", "dbo.T_BomSeatPosition");
            //    DropForeignKey("dbo.T_BomSeatInfo", "MaterialId", "dbo.T_BomMaterial");
            //    DropForeignKey("dbo.T_BomSeatInfo", "ColorId", "dbo.T_BomColor");
            //    DropForeignKey("dbo.T_BomSeatInfo", "AlcCodeId", "dbo.T_BomAlcCode");
            //    DropForeignKey("dbo.T_PlanDetail", "SeatPositionId", "dbo.T_BomSeatPosition");
            //    DropForeignKey("dbo.T_PlanDetail", "PlanId", "dbo.T_Plan");
            //    DropForeignKey("dbo.T_Plan", "PlanModeId", "dbo.T_PlanMode");
            //    DropForeignKey("dbo.T_Plan", "LineId", "dbo.T_BasicLine");
            //    DropForeignKey("dbo.T_Plan", "AlcCodeId", "dbo.T_BomAlcCode");
            //    DropForeignKey("dbo.T_BomPart", "SeatPositionId", "dbo.T_BomSeatPosition");
            //    DropForeignKey("dbo.T_BomPart", "AlcCodeId", "dbo.T_BomAlcCode");
            //    DropForeignKey("dbo.T_BasicLine", "WorkshopId", "dbo.T_BasicWorkshop");
            //    DropForeignKey("dbo.T_BasicWorkshop", "FactoryId", "dbo.T_BasicFactory");
            //    DropForeignKey("dbo.T_BasicLine", "ProductModeId", "dbo.T_ProductMode");
            //    DropForeignKey("dbo.T_BomLineAlcCode", "LineId", "dbo.T_BasicLine");
            //    DropForeignKey("dbo.T_BomLineAlcCode", "AlcCodeId", "dbo.T_BomAlcCode");
            //    DropForeignKey("dbo.T_BomALC", "CartypeId", "dbo.T_BomCartype");
            //    DropForeignKey("dbo.T_BomAlcCode", "StyleId", "dbo.T_BomStyle");
            //    DropForeignKey("dbo.T_BomStyle", "CartypeId", "dbo.T_BomCartype");
            //    DropIndex("dbo.T_BasicStation", new[] { "LineId" });
            //    DropIndex("dbo.T_BomSeatInfo", new[] { "MaterialId" });
            //    DropIndex("dbo.T_BomSeatInfo", new[] { "ColorId" });
            //    DropIndex("dbo.T_BomSeatInfo", new[] { "SeatPositionId" });
            //    DropIndex("dbo.T_BomSeatInfo", new[] { "AlcCodeId" });
            //    DropIndex("dbo.T_Plan", new[] { "PlanModeId" });
            //    DropIndex("dbo.T_Plan", new[] { "AlcCodeId" });
            //    DropIndex("dbo.T_Plan", new[] { "LineId" });
            //    DropIndex("dbo.T_PlanDetail", new[] { "SeatPositionId" });
            //    DropIndex("dbo.T_PlanDetail", new[] { "PlanId" });
            //    DropIndex("dbo.T_BomPart", new[] { "SeatPositionId" });
            //    DropIndex("dbo.T_BomPart", new[] { "AlcCodeId" });
            //    DropIndex("dbo.T_BasicWorkshop", new[] { "FactoryId" });
            //    DropIndex("dbo.T_BasicLine", new[] { "ProductModeId" });
            //    DropIndex("dbo.T_BasicLine", new[] { "WorkshopId" });
            //    DropIndex("dbo.T_BomLineAlcCode", new[] { "AlcCodeId" });
            //    DropIndex("dbo.T_BomLineAlcCode", new[] { "LineId" });
            //    DropIndex("dbo.T_BomALC", new[] { "CartypeId" });
            //    DropIndex("dbo.T_BomStyle", new[] { "CartypeId" });
            //    DropIndex("dbo.T_BomAlcCode", new[] { "StyleId" });
            //    DropTable("dbo.T_BasicStorage",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Storage_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BasicStation",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Station_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BomSeatInfo",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_SeatInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BomProcessType",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_ProcessType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_PlanMode",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_PlanMode_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_Plan",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Plan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_PlanDetail");
            //    DropTable("dbo.T_BomSeatPosition",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_SeatPosition_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BomPart",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Part_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BomMaterial",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Material_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BasicWorkshop",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Workshop_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_ProductMode",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_ProductMode_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BasicLine",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Line_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BomLineAlcCode",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_LineAlcCode_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BasicFactory",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Factory_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BomColor",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Color_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BomALC",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Alc_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BomCartype",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Cartype_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BomStyle",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_Style_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
            //    DropTable("dbo.T_BomAlcCode",
            //        removedAnnotations: new Dictionary<string, object>
            //        {
            //            { "DynamicFilter_AlcCode_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
            //        });
        }
    }
}
